Azure Blob

You can connect an Azure Blob target to the data flow, and load the ETL into Azure Blob as a delimited Text file.

Configure the Azure Blob Target

To load the ETL into an Azure Blob target, add the Azure Blob node from the Targets panel to the data flow.

• Azure Blob Target: select the required Azure Blob target from the server list drop-down
• Container: choose the required Container.
• Folder Path: enter the path to the given Container. This path can be a static value, or you can create a dynamic PQL expression in the PQL editor.
• Expression: enable this option to create a dynamic PQL expression to point to the folder path.

Next, click 'Connect All' to connect the target to the data flow.

From the File Properties window, set the properties of the Azure Blob file output:

• Encoding: provide the character encoding set for the new database file.
• Delimiters: select or enter the value delimiter.
• Text Delimiter: enter the text delimiter.
• Headers: if the file's first row is made up of column names, enable 'First row has column names'.

 

• Click here to learn more about Text file properties.

Target Tables

From the Target Tables window, you can rename the table outputs and change the writing type.

• Click here to learn more about target tables.

Description

Expand the Description window to add a description or notes to the node. The description is visible only from the Properties panel of the node, and does not produce any outputs. This is a useful way to document the ETL pipeline for yourself and other users.

Run the ETL

As there is no database or in-memory destination, the Data Model and Security stages are not relevant. Skip these steps and simply run the ETL from the Data Flow.